/*刷新物品记录*/
CREATE TABLE `mntmh_dorefreshlog` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`uin` INT(11) NOT NULL,
	`zoneid` INT(11) NOT NULL,
	`account` VARCHAR(100) NOT NULL,
	`ip` VARCHAR(50) NOT NULL,
	`create_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`type` INT(11) NOT NULL,
	PRIMARY KEY (`id`)
)
COLLATE=utf8_general_ci
ENGINE=InnoDB;

/*发物品记录*/
CREATE TABLE `mntmh_giftlog` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`uin` INT(11) NOT NULL,
	`zone_id` INT(11) NOT NULL,
	`account` VARCHAR(100) NOT NULL,
	`ip` VARCHAR(50) NOT NULL,
	`gift_type` VARCHAR(10) NOT NULL,
	`gift_name` VARCHAR(100) NOT NULL,
	`item_name` VARCHAR(100) NOT NULL,
	`item_man_id` VARCHAR(100) NULL DEFAULT NULL,
	`item_women_id` VARCHAR(100) NULL DEFAULT NULL,
	`status` INT(11) NOT NULL DEFAULT '0',
	`create_time` DATETIME NOT NULL,
	`gift_num` INT(11) NOT NULL,
	`is_big` INT(1) NOT NULL DEFAULT '0',
	`appletype` INT(1) NOT NULL,
	PRIMARY KEY (`id`)
)
COLLATE=utf8_general_ci
ENGINE=InnoDB;

/*物品配置*/
CREATE TABLE `mntmh_prize` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`giftid` INT(5) NOT NULL,
	`giftgroup` INT(5) NOT NULL DEFAULT '0',
	`reward_name` TEXT NOT NULL,
	`type` TINYINT(1) NOT NULL DEFAULT '0',
	`num_time` INT(20) NOT NULL DEFAULT '0',
	`pic` TEXT NOT NULL,
	`rate` VARCHAR(10) NOT NULL,
	`grouprate` VARCHAR(10) NOT NULL,
	`item_idg` CHAR(20) NOT NULL DEFAULT '',
	`item_idb` CHAR(20) NOT NULL DEFAULT '',
	`is_big` TINYINT(1) NOT NULL DEFAULT '0',
	`prize` INT(11) NOT NULL,
	`prizetype` INT(1) NOT NULL,
	PRIMARY KEY (`id`)
)
COLLATE=utf8_general_ci
ENGINE=InnoDB;

/*刷新次数记录*/
CREATE TABLE `mntmh_refreshlog` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`uin` INT(11) NOT NULL,
	`zoneid` INT(11) NOT NULL,
	`account` VARCHAR(100) NOT NULL,
	`ip` VARCHAR(50) NOT NULL,
	`create_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`type` INT(11) NOT NULL,
	PRIMARY KEY (`id`)
)
COLLATE=utf8_general_ci
ENGINE=InnoDB;

/*用户列表*/
CREATE TABLE `mntmh_userinfo` (
	`uin` INT(11) NOT NULL,
	`zoneid` INT(11) NOT NULL,
	`account` VARCHAR(100) NOT NULL DEFAULT '',
	`ip` VARCHAR(100) NOT NULL DEFAULT '',
	`createtime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`last_login_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`beuin` INT(11) NOT NULL DEFAULT '0',
	`bezoneid` INT(11) NOT NULL DEFAULT '0',
	`isback` INT(1) NOT NULL DEFAULT '0',
	`owncoin` INT(11) NOT NULL DEFAULT '0',
	`giftlist` TEXT NOT NULL,
	`usecoin` INT(11) NOT NULL DEFAULT '0',
	PRIMARY KEY (`uin`,`zoneid`)
)
COLLATE=utf8_general_ci
ENGINE=InnoDB;

/*扣钱记录*/
CREATE TABLE `mntmh_moneylog` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`uin` INT(11) NOT NULL,
	`zoneid` INT(11) NOT NULL,
	`account` VARCHAR(100) NOT NULL DEFAULT '',
	`ip` VARCHAR(100) NOT NULL DEFAULT '',
	`create_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`moeny_type` INT(11) NOT NULL,
	`moeny` INT(11) NOT NULL,
	`status` INT(11) NOT NULL DEFAULT 0,
	PRIMARY KEY (`id`)
)
COLLATE=utf8_general_ci
ENGINE=InnoDB;